CREATE VIEW [dbo].[vOnlineEventRegAnswers]
AS
SELECT    OrderAnswer.OrderNumber,
        OrderAnswer.QuestionID,
        OrderAnswer.Answer,
        EventSetupQuestion.Question,
        EventSetupQuestion.QuestionType,
        EventSetupQuestion.Required,
        EventSetupQuestion.QuestionOrder
FROM    OrderAnswer
        INNER JOIN EventSetupQuestion
        ON OrderAnswer.QuestionID = EventSetupQuestion.EventSetupQuestionID

GO